home *** CD-ROM | disk | FTP | other *** search
/ Utilities Professional 1-1500 / Utilities Professional 1-1500 (1994)(WPD)[!].iso / 00010250 / var0024.dms / var0024.adf / expsum.qry < prev    next >
Text File  |  1988-02-02  |  467b  |  21 lines
  1. ||||||||||||||||||||||||||||||||||||||||||||||||||||
  2. ||                                                ||
  3. ||  Example of expense summary for date range.    ||
  4. ||                                                ||
  5. ||||||||||||||||||||||||||||||||||||||||||||||||||||
  6.  
  7. select
  8.    (type = "C" or "W") and
  9.        (date > "123187" and date < "020188")
  10.  
  11. sort
  12.    ec
  13.  
  14. report
  15.  
  16.    bottom(ec)
  17.       ec total(amount) "%99,999.99"
  18.  
  19.    report_bottom
  20.       total(amount) "%99,999.99"
  21.